package cac.fenjian.resource.outStoreroom.dao;

import org.apache.ibatis.annotations.Param;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

public interface OutStoreroomDao {
    /*物料入库——出库操作*/
    public HashMap outStoreroomQuery(@Param("map") HashMap map);
    //配送出库
    public HashMap outStoreroomQuerySorting(@Param("map") HashMap map);
    /*物料入库首次叫箱*/
    public List<HashMap> outStoreroomFirst(@Param("map") HashMap map);
    /*零件、成品退货——出库操作*/
    public HashMap partOutStoreroom(@Param("map") HashMap map);

    //分拣管理缓存箱出库
    public List<HashMap> sortStoreRoomOut(@Param("map") HashMap map);
    //判断是不是叫同一个箱子
    public HashMap searchTask(@Param("map") HashMap map);

    //调用存储过程v1.0
    public HashMap callBle(Map map);
    //调用存储过程v2.0
    public HashMap searchWorkbinCode(Map map);
    //测试环境调用存储过程v2.0
    public HashMap searchWorkbinCodeTest(Map map);
    //调用标件叫箱存储过程正式环境
    public HashMap searchWorkbinCodeForBzj(Map map);
    //调用标件叫箱存储过程测试环境
    public HashMap searchWorkbinCodeForBzjTest(Map map);

    //调用退库叫箱存储过程
    public HashMap callReturnOutWorkbin(Map map);
    //查询当前库存数量及缓存箱号
    List<HashMap> nowWorkbinQty(@Param("map") HashMap map);
    //查询是否有大件物料
    public HashMap isBulkyItems(String itemCode);
    //插入大件货物进入到箱子临时表
    public int insertWorkbinDetal(@Param("map") HashMap map);
    //巷道开关
    public int rowTurn(@Param("map") HashMap map);
    //查询巷道是否被占用
    public String isRowOn(@Param("map") Map map);
    //修改货架表数据
    public int updateMsshevle(@Param("map") HashMap map);
    //手动完成正在执行的任务
    public int taskFinish(@Param("map") HashMap map);
    //手动清理当前位置流量
    public int isBackFinish(@Param("msGkLogId") String msGkLogId);
    //手动完成入库任务后将货架表上状态进行修改
    public int shelvesStatus(@Param("map") HashMap map);
    //yebo 2023-04-08 厂内代码同步，处理物料接收叫箱问题
    HashMap queryItemReciveStatus(@Param("map") HashMap map);
    int insertReceiveWorkbin(@Param("map") HashMap map);
    int updateMsGkLogIsBack(@Param("map") HashMap map);
    int updateReceiveWorkbin(@Param("map") HashMap map);
    int updateReceiveWorkbinStatus(@Param("map") HashMap map);
    int insertWorkBinReceDetail(@Param("map") HashMap map);
    int queryCurItemCodeWorkbinIsBack(@Param("map") HashMap map);

    //yebo 2023-11-07 增加查询是否为接收台
    int checkIsReceConsole(@Param("ip") String ip);
}
